Release 10.1A: OpenEdge Development:
Progress 4GL Reference

DISCONNECT statement

Disconnects the specified database.

Syntax

DISCONNECT { logical-name | VALUE ( expression ) } [ NO-ERROR ]

logical-name

A logical database name. It can be an unquoted string or a quoted string. The logical-name is previously set, at startup or with a CONNECT statement, by using the Logical Database Name (-ld) parameter. If a logical name was not specified using the -ld parameter, then the physical database filename, without the .db suffix, is the default logical name.

VALUE (expression)

A character-string expression that evaluates to a logical database name.

NO-ERROR

Specifies that any errors that occur when you try to disconnect are suppressed. After the DISCONNECT statement completes, you can check the ERROR-STATUS system handle for information on errors that might occurred.

Example

This procedure disconnects the database with logical name mydb:

r-discnt.p

DISCONNECT mydb.

Notes

By default, the Progress 4GL disconnects all databases at the end of a session. The DISCONNECT statement, which explicitly disconnects a database, does not execute until all active procedures that reference the database end or stop.
If a transaction is active for logical-name, DISCONNECT is deferred until the transaction completes or is undone. If a CONNECT statement for the same logical-name database is executed before the same transaction completes or is undone, then the pending CONNECT and DISCONNECT cancel each other and the database remains connected.
When the database referred to by logical-name is disconnected, existing aliases for logical-name remain in existence. Later, if you connect to a database with the same logical-name, the same alias is still available.

See also

ALIAS function, CONNECT statement, CONNECTED function, CREATE ALIAS statement, CREATE CALL statement, DATASERVERS function, DBCODEPAGE function, DBCOLLATION function, DBRESTRICTIONS function, DBTYPE function, DBVERSION function, DELETE ALIAS statement, FRAME-DB function, LDBNAME function, NUM-DBS function, PDBNAME function, SDBNAME function